dfa1fade4cd0d2243506d62e81854ec88531e362,portal-impl/src/com/liferay/portal/upgrade/v7_0_0/UpgradeRatings.java,UpgradeRatings,upgradeRatingsStats,#,139
Before Change
PreparedStatement ps = con.prepareStatement(selectSQL);
ResultSet rs = ps.executeQuery()) {
DatabaseMetaData databaseMetaData = con.getMetaData();
boolean supportsBatchUpdates =
databaseMetaData.supportsBatchUpdates();
try (PreparedStatement ps2 = con.prepareStatement(updateSQL)) {
int count = 0;
while (rs.next()) {
ps2.setInt(1, rs.getInt("totalEntries"));
ps2.setDouble(2, rs.getDouble("totalScore"));
ps2.setDouble(3, rs.getDouble("averageScore"));
ps2.setLong(4, rs.getLong("classNameId"));
ps2.setLong(5, rs.getLong("classPK"));
if (supportsBatchUpdates) {
ps2.addBatch();
if (count == PropsValues.HIBERNATE_JDBC_BATCH_SIZE) {
ps2.executeBatch();
count = 0;
}
else {
count++;
}
}
else {
ps2.executeUpdate();
}
}
if (supportsBatchUpdates && (count > 0)) {
ps2.executeBatch();
}
}
}
After Change
ps2.setLong(4, rs.getLong("classNameId"));
ps2.setLong(5, rs.getLong("classPK"));
ps2.addBatch();
}
ps2.executeBatch();
}
}
}